Merge two data tables from two different excel workbook and match columns

[pattyricarte (Patty Boy)]

No worries.Just need to go home .Dont worry tomorrow i will send it.

cheers

Happy learning

[Sugaray]

Good morning @pattyricarte
Were you able to send the xaml files for my question above? Thank you again for your support.

[pattyricarte (Patty Boy)]

Hi @Sugaray Good eve.

Kindly see attachment below for your reference.

Note change the path of all the necessary excel.SugarRay.zip (24.0 KB)

cheers

Happy learning :smiley

[Sugaray]

Thank you so much! I will take a look at it right now.

[pattyricarte (Patty Boy)]

Welcome

@Sugaray

cheers:D

Happy learning

[Sugaray]

Good evening @pattyricarte

Could you please take a look at my xaml file? I have incorporated your steps with some steps of mine that would take place before your steps. However I am getting an error in the sequence steps “Get the Output”. The error says it can’t find the range. I used your steps and renamed some variables but it should still work right? I tried chance the Variables scopes but still no luck. Could you please tell me what I did wrong? Thank you for your help. nVision to Master Join.xaml (41.9 KB)

[pattyricarte (Patty Boy)]

Ok @Sugaray
But later right now i cant access my laptop i am just replying thru mobïle.

cheers

[Sugaray]

Thank you!

[pattyricarte (Patty Boy)]

Hi @Sugaray
I got the xaml but can you show some screenshot where the errors came from ?

cheers

Happy learning

[Sugaray]

Hi @pattyricarte,
Please see the attached screenshot of error bouncing back.

[pattyricarte (Patty Boy)]

Ok @Sugaray

Can i see the excel file ----In_StrOutputExcelPath ?

cheers

Happy learning

[Sugaray]

So I am trying to add a new sheet on the same workbook as of In_StrExcelPathSecond using the output dt of the Join Wizard.

[pattyricarte (Patty Boy)]

Is this the value of this variable ?
In_StrOutputExcelPath

I dont see any issue on it you have sheetname and the range is there!

How about your dataable did you get value on it ?

cheers

Happy learning

[Sugaray]

So the sheet “TRP Oct 19” is created by the bot but however the data table is not added by the sequence.
Both In_StrOutputExcelPath and In_StrExcelPathSecond use the same workbook destination. I don’t get an issue while creating the out put DT of the Join Wizard from the previous sequence.