Hello everyone,
I am working on a project and need assistance with segregating output values. Specifically, I want to segregate the values and only retrieve the ones corresponding to a particular column.
Can someone guide me on how to achieve this or suggest a solution within Appian to isolate the values from a specific column?
Any help would be greatly appreciated!
Thank you in advance!
Discussion posts and replies are publicly visible
Can you explain the expected output in more detail?
hello
a!localVariables( local!data: {Column_1: "Acctg Period Dt Txt", Column_2: "Time Period Yr Dt", Column_3: "Mo Num", Column_4: "World Region", Column_5: "Country Code", Column_6: "Country Name", Column_7: "Ups Co Num", Column_8: "Ups Co Name", Column_9: "Expng Ctr Reg Num", Column_10: "Expng Ctr Reg Name", Column_11: "Expng Ctr Dist Num", Column_12: "Expng Ctr Dist Name", Column_13: "Expng Ctr Num", Column_14: "Prod Num", Column_15: "Gl Acct Num", Column_16: "Gl Acct Num Desc Txt", Column_17: "GL Accounting String", Column_18: "Context Name", Column_19: "Ctxt Transaction Type", Column_20: "Ctxt Journal Type", Column_21: "Clnt Num", Column_22: "Vat Code", Column_23: "Vndr Num", Column_24: "Vndr Name", Column_25: "Po Num", Column_26: "Po Crtn Dt", Column_27: "Inv Num", Column_28: "Sending Company", Column_29: "Sending RRDD", Column_30: "Sending Center", Column_31: "Receiving Company", Column_32: "Receiving RRDD", Column_33: "Receiving Center", Column_34: "Orgtng Expng Acct Num", Column_35: "GIS Number", Column_36: "GIS Jrnl Desc Txt", Column_37: "Transaction Category", Column_38: "Gl Jrnl Srce Type Cd", Column_39: "Gl Jrnl Srce Type Cd Desc Txt", Column_40: "Gl Jrnl Batch Desc Txt", Column_41: "Gl Hdr Name", Column_42: "Gl Jrnl Line Desc Txt", Column_43: "Image Number", Column_44: "Inv Dt", Column_45: "Tax Code Description", Column_46: "Tax Type", Column_47: "Gl Posted Date", Column_48: "Bus Rule Name", Column_49: "Keyd Documt Batch Desc Txt", Column_50: "Ent Curr Cd", Column_51: "Debit Ent Curr Amt", Column_52: "Cr Ent Curr Amt", Column_53: "Net Ent Curr Amt", Column_54: "Func Curr Cd", Column_55: "Debit Func Curr Amt", Column_56: "Cr Func Curr Amt", Column_57: "Net Func Curr Amt", Column_58: "Stdzd Curr Cd", Column_59: "Debit Stdzd Curr Amt", Column_60: "Cr Stdzd Curr Amt", Column_61: "Net Stdzd Curr Amt", Column_62: "Company", Column_63: "RRDD", Column_64: "Center", Column_65: "Operation", Column_66: "Product", Column_67: "Account", Column_68: "GIS Jrnl Desc Txt and Inv Num", Column_69: "rate"}, local!keys: a!keys(local!data), a!forEach( local!keys, property(local!data, fv!item) ) )
Mike Schmitt Thanks Mike