Help to Join horizontal data set to vertical dataset

[Bakiyaraja]

Hi all need a workflow to  Join horizontal data set to the vertical dataset  i tried last one week but no luck.

[martinding · Accepted solution]

Hi @Bakiyaraja,

If your data come in the same way as you described, then the attached should work.

But I would recommend you to actually create two tables in the data engineering step, and each table should have the appropriate keys for joining. This will make your life much easier and less prone to errors.