Need to create Calculted column with same values

[former_member193552]

Need to fill TextPosHub with value RIGHT in every cell. Idea is to get respective value from TextPosSub for PA and put every where. Can this be done ?

[former_member193552]

This is done via Graphical interface. I was only able to populate one field as you can see in TextPosHub. I need to repeat same value for other columns. TextPosHub is calculated column.

One hub can have multiple countries and position for CountryISOCode is determined by flag TextPosHub. Similary we are using HubISOCode to determine which CountryISOCode flag value we can use.. in this example PA is value that we need to consider while populating TextPosHub column. All should have RIGHT, RIGHT and RIGHT

.. Calculated column was like this if ( CountryISOCode = HubISOCode, TextPosHub,'')

But this is only good for one cell I need to do for all cells and display same text.

[former_member193552]

Is it clear now?

[former_member193552]

HubISOCode determines which row to pick from CountryISOcode and then against CountryISOCode whatever value we have in TextPosSub, we need to use that and update every cell of TestPosHub.

[pfefferf · Accepted solution]

Depending on the further information you provided in the comments I would suggest to join your result data on your identifying key (Country = Country + CountryISOCode = HubISOCode). Then you are able to use the value of TextPosSub (available in the line for the matching CountryISOCode) as TextPosHub.

Regards,
Florian