Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to transform it like that :
what can i do ?
What does the data look like in the source(s)?
Is it a table like the first image, or are it multiple files?
there are multiple files
Can you share samples/examples for the structure of the files so we can try to contruct the data structure you want?
It looks like the files have been concatenated when they should have been joined using common key fields.
I agree with @LRuCelver . Can you try joining the files