How to Merge two different Input file Using File Browse Tool

[areeba]

Hi

I have  2 input files which are totally different and i am using  File Browse tool to upload the input files in both of them .

I need to merge these 2 files together displaying all columns , How can i achieve it ?

Since i am using File browse tool , its not advisable to use Union tool's Manually configure columns option.

Can you advise , how can i merge and get all columns from both files.

Regards

Areeba

[atcodedog05]

Hi @areeba 

Are the column names of 2 files always same or does it change.

[areeba]

Hi @atcodedog05 

Its same at present , but never know if client changed it in future.

[messi007]

Dear @areeba,

Could you share a sample screen shot of the workflow and sample of the data in order to help 🙂

Regards,

[atcodedog05]

Hi @areeba 

So what i would suggest is, since we know columns doesnt change until the client changes it.

You wouldnt have to touch the union tool manual configuration unless client changes.

If client does change the columns 2 things might happen

1. Client inform you about the changes and you can update workflow accordingly.

2. Client doesnt inform if there is change in column name it will throw error.

If the column names keeps changing its not possible to build a stable workflow

These are the things i can think off 😅 let me know what are your thoughts.

[areeba]

Hi @atcodedog05 @messi007 

Please Find attached sample files , i want to merge . Also see my workflow picture and expected output:

Output expected:

A          B           C         D              1           2        3

Hi         Hello   hoi       HEYA       yes       no      yes

Bye      Dooi    Tada    daag        no        no       yes

Ok       done     fine     top

[atcodedog05]

Hi @areeba 

Did you take look at the previous reply any thoughts on that? 

[areeba]

Hi @atcodedog05 @messi007 

The columns are not going to change.

Let me rephrase my requirement.

I have 2 files which do no have any common filed.

I want to generate a new column which involves both input files with following condition

IF LEVEL1= WORK then FUNCTION

ELSE 'N/A'

ENDIF.

Please find attached new two files.

Can you suggest?

Regards

Areeba

[messi007]

Hello @areeba ,

Below the output. I think you have to use the append field or find Replace tools 🙂

Attached the WF,

Regards,

[atcodedog05]

Hi @areeba 

I took at look at your files. Still bit confused can you provide with a expected output.

Thanks 🙂