Add conditions to run different part of the PQ code

[Bassil74]

I have this part of my script that i need to make it run different parts of the code based on the language:

let

    Language = "En",

    //Language = "Fr",

    //Language = "Sp",

    .

    .

    .

  If Language = "En" then run this part

      Expandmeasurement = Table.ExpandRecordColumn(Table.ExpandListColumn(MergeColumns, "measurements"), "measurements", { "Reached", "monitoringPeriodId,""CumulativeReach"}, {"Reached", "monitoringPeriodId","CumulativeReach"}),

    ReorderColumns = Table.ReorderColumns(WithMp_Number,{"monitoringPeriodId", "Reached", "CumulativeReach"}),

 elsif 

Language = "Fr" then run this part

      Expandmeasurement = Table.ExpandRecordColumn(Table.ExpandListColumn(MergeColumns, "measurements"), "measurements", { "Atteints", "monitoringPeriodId","Cumulatteints"}, {"attent", "monitoringPeriodId","Cumulatteints"}),

    ReorderColumns = Table.ReorderColumns(WithMp_Number,{"monitoringPeriodId", "Atteints", "Cumulatteints"}),

elsif 

Language = "SP" then run this part

      Expandmeasurement = Table.ExpandRecordColumn(Table.ExpandListColumn(MergeColumns, "measurements"), "measurements", { "Atendidas", "monitoringPeriodId","Alcance cumulativo"}, {"Atendidas", "monitoringPeriodId","Alcance cumulativo"}),

    ReorderColumns = Table.ReorderColumns(WithMp_Number,{"monitoringPeriodId", "Atendidas", "Alcance cumulativo"}),

in

ReorderColumns

Apprecaite any ideas about it, thank you

[Bassil74]

To clarify, i want a script that branch logic to  implement scertain parts:

I need help to include a condition in my steps for the below part: 

    Language = "En",

    //Language = "Fr",

    //Language = "Sp",

 

  If Language = "En" then      Expandmeasurement = Table.ExpandRecordColumn(Table.ExpandListColumn(MergeColumns, "measurements"), "measurements", { "Reached", "monitoringPeriodId,""CumulativeReach"}, {"Reached", "monitoringPeriodId","CumulativeReach"}),

    ReorderColumns = Table.ReorderColumns(WithMp_Number,{"monitoringPeriodId", "Reached", "CumulativeReach"}),

 els if 

Language = "Fr" then run this part

      Expandmeasurement = Table.ExpandRecordColumn(Table.ExpandListColumn(MergeColumns, "measurements"), "measurements", { "Atteints", "monitoringPeriodId","Cumulatteints"}, {"attent", "monitoringPeriodId","Cumulatteints"}),

    ReorderColumns = Table.ReorderColumns(WithMp_Number,{"monitoringPeriodId", "Atteints", "Cumulatteints"}),

els if 

Language = "Sp" then run this part

      Expandmeasurement = Table.ExpandRecordColumn(Table.ExpandListColumn(MergeColumns, "measurements"), "measurements", { "Atendidas", "monitoringPeriodId","Alcance cumulativo"}, {"Atendidas", "monitoringPeriodId","Alcance cumulativo"}),

    ReorderColumns = Table.ReorderColumns(WithMp_Number,{"monitoringPeriodId", "Atendidas", "Alcance cumulativo"}),

in

Expandmeasurement 

Thank you,

[lbendlin]

 your code results in different column names which will trigger a meta data update, and is generally considered to be a bad thing. Would be better if you would keep the column names constant and carry the language choice through as a separate column.

[lbendlin]

replace "elsif"  with "else if"  and you should be good.

or you could refactor the code and move the checks inside the list.

However your code results in different column names which will trigger a meta data update, and is generally considered to be a bad thing. Would be better if you would keep the column names constant and carry the language choice through as a separate column.

[Bassil74]

THank you @lbendlin . The data is fetched from an API which has columns values stored in three languages, i.e. "Reached", "Atteints", "Atendidas". Iam now rethinking it, to store these values in a separate table i.e. measurementsLanguages

Language      | Value1       |  Value2

En                  | Reached    | CumulativeReach

Fr                  | Atteints      | Cumulatteints

and use them based on the language selected.

let

    Language = "En",

    //Language = "Atteints",

    //Language = "Atendidas",

 

 If Language = "En" then run this part

     Expandmeasurement = Table.ExpandRecordColumn(Table.ExpandListColumn(MergeColumns, "measurements"), "measurements", { "Reached", "monitoringPeriodId,""CumulativeReach"}, {measurementsLanguages[Value1], "monitoringPeriodId",measurementsLanguages[Value2]}),

    ReorderColumns = Table.ReorderColumns(WithMp_Number,{"monitoringPeriodId", "Reached", "CumulativeReach"}),

...etc

But this didn't wok as it assume measurementsLanguages is the datasource and is not fetching the column names. Do you have any better way of doing it?