Forum Discussion
create column dynamically from other table
dorsey , it is better to unpivot the second table in power query and get first name. Then you can create a common first name column
Hey !
Thank you for your answer, it's working perfectly and I think it will be very usefull.
But finaly, my problème is unsolved, my fault of course because it's a logical problem.
I need to find if my user have check this day or not, and I think finaly I need to combinate two table.
the first one don't change but the seconde one need to create the row dynamicaly.
I explain :
the first one is always :
NAME SURNAME John Doe John Maclane Mary Poppins but the second one need reppeat the date any time there is user on the first table :
DATE ||NAME ||SURNAME 01/01/2021 John Doe 01/01/2021 John Maclane 01/01/2021 Mary Poppins 02/01/2021 John Doe 02/01/2021 John Maclane 03/01/2021 John Doe 03/01/2021 ... ... Hi dorsey,
For rows 2021/2/1,why there are only 2 rows?Shouldnt there be 3 rows,which is same as 2021/1/1?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Hi,
Thank you for reply.
Not really because it's a table for the holiday who user have take. For exemple the 2021/1/1, three persons have take the day but the day after only two
regards.
