Skip to Content

Need to create Calculted column with same values

Apr 26, 2017 at 04:12 PM


avatar image

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 ?

xhohn.png (23.5 kB)
10 |10000 characters needed characters left characters exceeded

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.


Is it clear now?
xvty2.png (53.5 kB)

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.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Apr 27, 2017 at 05:12 AM

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.


10 |10000 characters needed characters left characters exceeded