Forum Discussion

gabrielvigo's avatar
gabrielvigo
Icon for Helper I rankHelper I
8 years ago
Solved

Composite keys

Hello everyone.   I'm trying to put together a composite key between two fields from the query editor. But it returns error, and I am using the correct syntax.   For example, I have two fields "d...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi gabrielvigo,

     

    Try it like this:

    Table.AddColumn(#"Changed Type", "key", each [Market] & " " & Text.From([Fecha]))

    Composite_keys

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi gabrielvigo,

 

Try it like this:

Table.AddColumn(#"Changed Type", "key", each [Market] & " " & Text.From([Fecha]))

Composite_keys

 

Best Regards,

Dale