Filter Data with contains

[indrajit.shah]

Hi,

I have two excel files -
1st excel file - One is having Column Name “Payment reference”
2n excl file - Column Name “Trans Item”

My Query -
-I have 2 DateTable DT1 and DT2
-From DT1 column name “Payment reference” have data(string) and in DT2 column named “Trans Item” which contains the string from DT1.
-I have to filter those records from DT2 and write in a different excel with complete data from DT2.

Attaching both the excel for example Ref.xlsx (8.5 KB) TransItem.xls (22 KB)

[kadiravan_kalidoss]

Sample output sheet pls @indrajit.shah

Thanks!

[supermanPunch]

@indrajit.shah I would say the Filter Criteria you have Specified is Not Quite clear. Can you Explain in Detail the Process you want to Perform. Screenshots are preferred.

[indrajit.shah]

@kadiravan_kalidoss

Final_TransItem.xls (20.5 KB)

[indrajit.shah]

@supermanPunch - I have update my post can you please check once.

[Manish540]

Check this workflow, @indrajit.shah
Excel_DataUpdation.xaml (10.4 KB)
and the output file
Final_Transac_item.xlsx (7.5 KB)

[indrajit.shah]

@Manish540

Thank you, this is simple one, i was trying much complicated one.

this solution let me with one question -
Is it filtering just like we do in excel?? like searching the string in the trans sheet trans item column? and is there any question it will return with duplicate records??

[Manish540]

It will return the duplicate records also…for that you can groupby after filtering.

[indrajit.shah]

okay,

can you please look this one as well

Segregate data and create two DT from one DT

Hi, -I have to read an excel and have to segregate data from that excel and make 2 DataTable, I have attached the sample excel and also a screenshot. -in 1st DT the data will have the A1:B19 and in 2nd DT rest of the data. [image] tesdata1.xlsx (11.4 KB)

[indrajit.shah]

@Manish540, with this solution i need lill more help.