Append data

[Tid14]

Hi,

I am facing a challenge in my workflow wherein I have two inputs file INPUT 1 and INPUT 2 and  I want to append them in a way as shown in the attached output file. I have been trying to populate it but no luck till now. 

Also If i can populate these Debit and Credit amount as shown in the Output?

Both these amount are coming from the first row of Amount column. Debit + amount, Credit - amount.

Thanks in Advance

[IraWatt]

Hey @Tid14,

Is this the kind of output you are looking for?

[Tid14]

Yes somewhat like this only.

Can you send me the workflow in yxmd format so that i can look into the configurations.

I am not able to import yxzp file.

Thanks

[IraWatt]

Sure no worries @Tid14 I've attached it here:

[ChrisTX]

For SAP, should the debit/credit amount be based on the Posting Key, or based on a field like this:  BSEG_SHKZG Debit/Credit Ind.

Chris

[IraWatt]

Hey @Tid14 The settings I on the 2nd data set was just to tick here:

I then just appended on position with Input 1 as Connection 1:

[grazitti_sapna · Accepted solution]

@Tid14, added credit and debit values to the dataset as requested.

I hope this helps!

Thanks!