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

[areeba]

Hi @atcodedog05 

I am Expecting to merge two different files in a way that in the new column i get following Data:

Condition (formula for new column in Output file)

If Level1(File 1) = Work(File 2) then Function(Value Function)

Elseif Level2(File 1) = work (File 2) then Function (Value of Function)

Else '#N/a'

Endif.

Please find attached  example:

Can you suggest ?

[messi007 · Accepted solution]

@areeba,

Could you check the attached workflow 🙂

Hope that helps,

Regards,

[areeba]

Hi @atcodedog05 ,

I tried applying Append tool but it did not work out well with my files. So i used join tool and made it full outer join twice  to merge my 2 different files. It worked well.

I have formula which is creating a new column 'New Column' by taking 2 files:

If Level1(File 1) = Work(File 2) then Function(Value Function)

Elseif Level2(File 1) = work (File 2) then Function (Value of Function)

Else '#N/a'

Endif.

For eg:

File 1

Employee_ID      Level1         Level2 

1001                    Support      

1002                    Director       Line

1003                    Trader          Manager

File 2:

Work              Function

Support          Direction

Line                 Services

Power             Change

Which is giving this Output:

Employee ID             Level1        Level2                      New Column

1001                          Support      blank(no null)         Direction

1002                          Director      Line                          Services

1003                          Trader         Power                      #N/A

Now, My requirement is : Is it possible to put a check  that if that 'New Column ' gives 'N/A' value then  user interface appears ask user to fill column Work ,Function (of file 2) and update file 2  with a new line ;

Expected Output:

File 2

Work              Function

Support          Direction

Line                Services

Power            Change

Utility             operation (new line)

Regards

Areeba

[atcodedog05]

Hi @areeba 

I dont think that this is much of a possibility 😅

Sorry

@messi007 any inputs ?

[areeba]

@atcodedog05 

i dont want to update the existing file 2 , a new Output file with that addition of a row.

[atcodedog05]

@areeba 

issue is with interface part 😅

[atcodedog05]

Ok is it only one row to be added to file2 ?

Let me take a look.

[areeba]

It is like with the requirement that whenever they  hit 'N/A' then a prompt comes to enter value of WORK , FUNCTION  and whatever user enters the value in these two columns it gets updated in output as a new line. It could be the case more that 1  N/A value appears 

[atcodedog05]

Hi @areeba 

I took a look at it. Its really very complicated to make it work😶

Sorry 😶

[areeba]

@atcodedog05 

😔☹️

If you come up with any workaround , Please let me know

@messi007 , Can you please try with your solution(AppendFields workflow)

Thanks 

Areeba