How to manage multiple same data file ?
Hi All
I have sales order raw data file for :-
Company A
Company B
Company C
Company D
My old approach is create 4 similar set of script. And I concatenance all Table into one table. For this I need to use 4 Tab. And need to repeat 4 time for same recode field. Very messy
New approach I want to try is using loop . For this the adv is I only using one Tab. For recode same field I only need do once , very neat.
May I know it there any better approach ?
Paul
