Newbi question, if i have a table where i want to splitt a collumn into two how woud I do that. Existing formatColumn a , Column B, Column CIndex,0,02022-01,100,2452022-02,101, 1452022-03, 90, 200North,0,02022-02,23, 1232022-03,35,250South,0,02022-01,87,100 Now I need to isolate the column a and the heading values, Index, North, South and make a new column Column a , Column B, Column C, New ColumnIndex,0,0,index2022-01,100,245, index2022-02,101, 145, index2022-03, 90, 200, indexNorth,0,0, north2022-02,23, 123, north2022-03,35,250, NorthSouth,0,0, South2022-01,87,100, South The source can be an excel or a db table. Target is a db tableHow do I do that?

Split a column into two

Just to make sure I have this right, essentially you want to take the value from Column A and set it on the following columns until it changes from Index to North/South/etc?

2022-02-14_13-46-23 If so, you can get this done using the adjacent feature handling feature in the AttributeManager. Since adjacent feature handling requires the attribute to already exist, you'll first need to use an AttributeCreator or AttributeManager to create column D. Then, in an AttributeManager set the number of prior features to 1 and set the following conditional value for column D.

2022-02-14_14-02-57 I've attached a sample workspace and dataset in case that helps. From there, you can write it out to whatever format you'd like. Simply type the name of the format or use the add writer button and connect it to the AttributeManager.

Output:

2022-02-14_14-06-45

Hi @danketil ,

Just to make sure I have this right, essentially you want to take the value from Column A and set it on the following columns until it changes from Index to North/South/etc?

2022-02-14_13-46-23 If so, you can get this done using the adjacent feature handling feature in the AttributeManager. Since adjacent feature handling requires the attribute to already exist, you'll first need to use an AttributeCreator or AttributeManager to create column D. Then, in an AttributeManager set the number of prior features to 1 and set the following conditional value for column D.

2022-02-14_14-02-57 I've attached a sample workspace and dataset in case that helps. From there, you can write it out to whatever format you'd like. Simply type the name of the format or use the add writer button and connect it to the AttributeManager.

Output:

2022-02-14_14-06-45

Great Job @chrisatsafe

Hi @danketil ,

Just to make sure I have this right, essentially you want to take the value from Column A and set it on the following columns until it changes from Index to North/South/etc?

2022-02-14_13-46-23 If so, you can get this done using the adjacent feature handling feature in the AttributeManager. Since adjacent feature handling requires the attribute to already exist, you'll first need to use an AttributeCreator or AttributeManager to create column D. Then, in an AttributeManager set the number of prior features to 1 and set the following conditional value for column D.

2022-02-14_14-02-57 I've attached a sample workspace and dataset in case that helps. From there, you can write it out to whatever format you'd like. Simply type the name of the format or use the add writer button and connect it to the AttributeManager.

Output:

2022-02-14_14-06-45

chrisatsafe

Sorry for my late reply, yes that is correct

I tried your solution but it only works for the first row, it does not replicate the value Index for all rows

Hi @danketil , I got this table from @chrisatsafe 's workspace. Isn't this your desired one?

result

This is how the model now looks

and below you find the dataset from query

As you can see it is correct for the first row but it does not apply teh rule for the rest of the rows

This is how the model now looks

and below you find the dataset from query

As you can see it is correct for the first row but it does not apply teh rule for the rest of the rows

Your conditional value setting seems to be wrong. I think it should look like this. conditional-value-setting

Thanks I figured out what I did wrong. Now it works.

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded