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 Stefan,
I want to segregate the output values like this :
hello
You said you need the data from one column. That appears to be the data from all columns from a particular row. Can you explain in a bit more detail what exactly the source information is and what output you want, and why?
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