Concatenate issue

[#1]

So I am concatenating my tables together because I was ending up with synthetic keys that were actually messing up my data. But now, the script you gave to me isn't working. It was fine up until I concatenated them, and now it's coming up with a wrong answer. Am I putting the concatenation in the wrong place?

krishnachaitanya‌

[Qrishna]

could you please attach whatever excel files you are using in the application with some data.(say 50 lines in each excel) so that i can do some trial and error techniques?

[#3]

I can attach one but editing all of them so that I can attach them here would take a very long time... I am using excel files that are pulled daily so there are files from every single da

[Qrishna]

Ok No worries. Give me some time. Will figure out something.

[Qrishna]

Alex,

Please See the script from the attached doc.

[#6]

Is there a reason you made all of them named [Aged Orders - April]? I'm just curious

[Qrishna]

Oh My bad... Every month should have its own name except the parent table.

Parent table:

march : [Aged Orders_temp]  and [Aged Orders]                             

Child: (you concatenate child to parent to get the final table after reload)

April : [Aged Orders - April_temp]  and [Aged Orders - April]

May : [Aged Orders - may_temp]  and [Aged Orders - may]

june: [Aged Orders - jun_temp]    and  [Aged Orders - jun]   etc etc

[Qrishna]

let me know if everythings going well.

[#9]

I am trying to fix a few different things at once so I will let you know!!