Append data

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

Input 1.xlsx

Input 2.xlsx

Output pqrs.xlsx

Workflow

Datasets

Developer

Output

Dynamic Processing

Accepted answers

grazitti_sapna

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

I hope this helps!

Thanks!

Tid14_workflow.yxmd

All comments

IraWatt

Hey @Tid14,

Is this the kind of output you are looking for?

Example.yxzp

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:

Workflow.yxmd

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

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

I hope this helps!

Thanks!

Tid14_workflow.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703