Forum Discussion

msupg21's avatar
msupg21
New Member
2 years ago
Solved

Writing a conditional column from another column in another table

Table 1 has a column: [region = "3300" as text] Table 2 has a column [station = "3300 - Southwest Office"] Essentially, I need to lookup values from table 2's "station" column using table 1's "regi...
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI,msupg21 

    Regarding the issue you raised, my solution is as follows:

    1.First I have created the following table and the column names and data are the data you have given:

    2.Then station table add custom columns in PowerQuery:

    Text.Start([station],4)

    3.Finally, use the merge query in the region table to expand:

    4.Here are my end results, I hope to meet your needs:

    Note that the data types of the columns are consistent when merging queries.

     

    Please find the attached pbix relevant to the case.

     

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI,msupg21 

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2.Then station table add custom columns in PowerQuery:

Text.Start([station],4)

3.Finally, use the merge query in the region table to expand:

4.Here are my end results, I hope to meet your needs:

Note that the data types of the columns are consistent when merging queries.

 

Please find the attached pbix relevant to the case.

 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.