Forum Discussion
Haimsalem
Aug 18, 2021Copper Contributor
Help with v-loomup
Hi evreyone,
Im using execl to follow my orders.
The thing is there is always new orders in my system.
Evrey months i have to download new excel files from the system and i wants to add the new excel infos to my old one without copy orders that i got there already.
The work circle need to be like have 1 excel file (with errors and meesages i leave in) and evrey month import to that file new orders from another files.
Same tables at both of the files, for example its like:
1. Adress 2. Order number 3. Date opend 4. status.
Im using execl to follow my orders.
The thing is there is always new orders in my system.
Evrey months i have to download new excel files from the system and i wants to add the new excel infos to my old one without copy orders that i got there already.
The work circle need to be like have 1 excel file (with errors and meesages i leave in) and evrey month import to that file new orders from another files.
Same tables at both of the files, for example its like:
1. Adress 2. Order number 3. Date opend 4. status.
4 Replies
- Rajesh_SinhaIron ContributorIf possible please share the WB or some sample data along with results in expected format will help us to fix it !!
- HaimsalemCopper Contributor
- Rajesh_SinhaIron ContributorSorry dear Haimsalem posted image can't help me to understand the issue,,, I've demanded for the WB coz,,, I can check the formula considering data to decide how far is correct & what is the bug,,, it's large data set !!