How to combine different datas in one sheet

[Belletmns]

Hi All,

I want to combine two different data into one sheet. Should look like this:

3. On Hold
EID	EE	Start	End	Remarks
xx	x	x	x	x
x	x	x	x	x
xx	x	x	x	x
4. Intern
EID	EE	Start	Allow	Remarks
x	x	x	x
x	x	x	x

Thanks!

[wdavis · Accepted solution]

Hi @Belletmns 

I have attached a workflow with 2 options of how you can do this.

The first is simply stacking them together in a Union to give an output as you have identified below.

The second creates logic so that each record has the filename associated with it. This would make it easier to do any processing further down the line with all the data in one tabular format.

Let me know if this works for you!

Kind Regards,

Will

[Belletmns]

@wdavis thank you!