Forum Discussion
Surya1
8 years agoHelper I
Help needed in power query
Hi Can some one helpme.I am new to powerBI.I have a scenario explained below. I have two tables Table 1 col 1 col 2 col3 abc bnn fffg hhh Table 2 col 1 04/04/2...
- 8 years ago
I feel this is the solution you want ,you can concatenate the columns for the appropriate output
Hardik
8 years agoContinued Contributor
I feel this is the solution you want ,you can concatenate the columns for the appropriate output
- Surya18 years agoHelper I
Thank You So much for your help.
For each entry in col 1 of table1 i have different patterns to follow while concatenating.So i may need an IF to concatenate.
Can we do the cross join and if conditions in one step.
- Hardik8 years agoContinued Contributor
I am not aware about your exact requirements for concatenation ,but this is what you can do .