String Parsing

[varshanswamy]

How do I further use the pivot function I am unable to follow. Could you please help on this

Hi Varsha,

You can use the Convert function to convert all the "&" to ","
So after conversion your data will look as follows

1,A=B,C=D,E=F,G=H
2,L=M,G=H

Then you can use the pivot to pivot the data and get the result in the required format

1, A=B
1, C=D
1, E=F
1, G=H
2, L=M
2, G=H

[ray.wurlod]

There is no pivot function. There is a Pivot stage. It has its own manual and its own help, and is quite easy to use. Indeed, an earlier poster provided all the information you need.

[varshanswamy]

I am still unable to get the required result through the pivot stage as mentioned, I did try using the pivot stage, in the derivation of the Output Tab of pivot I am uable to get the required result.
If I put the value of the key, string in the derivation I get the key in the first row and the entire string in the next row.

[Sunshine2323]

How do I further use the pivot function I am unable to follow. Could you please help on this

Hi Varsha,

You can use the Convert function to convert all the "&" to ","
So after conversion your data will look as follows

1,A=B,C=D,E=F,G=H
2,L=M,G=H

Then you can use the pivot to pivot the data and get the result in the required format

1, A=B
1, C=D
1, E=F
1, G=H
2, L=M
2, G=H

Lets go one step at a time,

Step1) Have you used the Convert function and got the above mentioned result?

After you convert the data pass it to a Sequential file.

Now try reading the data in a newSequential file with delimiter as ","

Lets say your View Data looks like this,
Key Field1 Field2 Field3 Field4
1 A=B C=D E=F G=H
2 L=M G=H

Step2) Pass the data through a Pivot. For more help on Pivot stage you can read Pivot.pdf
In the output tab of the Pivot stage, enter only 2 columns

ColumnName Derivation
Key Key
Field Field1,Field2,Field3,Field4

Now dump this Output to sequential File.

Step 3) You will get null values where Field3 and Filed4 are null. You can pass the data through a Transformer before dumping it to a Sequential file with the constraint Not(IsNull(Field))

And you will get the required result.

Hope this helps.

[varshanswamy]

I have problem here, if there are 2 ampersands in one string and 4 ampersands in another string it is creating a problem for me, when I read the file in step 2 it is overwritng the first line with the second line, that is I get only one row having Field1 Field2 Field3 and Field4

How do I further use the pivot function I am unable to follow. Could you please help on this

Hi Varsha,

You can use the Convert function to convert all the "&" to ","
So after conversion your data will look as follows

1,A=B,C=D,E=F,G=H
2,L=M,G=H

Then you can use the pivot to pivot the data and get the result in the required format

1, A=B
1, C=D
1, E=F
1, G=H
2, L=M
2, G=H

Lets go one step at a time,

Step1) Have you used the Convert function and got the above mentioned result?

After you convert the data pass it to a Sequential file.

Now try reading the data in a newSequential file with delimiter as ","

Lets say your View Data looks like this,
Key Field1 Field2 Field3 Field4
1 A=B C=D E=F G=H
2 L=M G=H

Step2) Pass the data through a Pivot. For more help on Pivot stage you can read Pivot.pdf
In the output tab of the Pivot stage, enter only 2 columns

ColumnName Derivation
Key Key
Field Field1,Field2,Field3,Field4

Now dump this Output to sequential File.

Step 3) You will get null values where Field3 and Filed4 are null. You can pass the data through a Transformer before dumping it to a Sequential file with the constraint Not(IsNull(Field))

And you will get the required result.

Hope this helps.

[T42]

Do your own job, or pay someone to do it for you. I refuse to help people who expect the complete code, and refuses to understand what is going on here. There are wonderful advices that a person who is capable of using PX can easily utilize to create a job.

Do what you are hired to do, or pay someone else to do it for you.

[ArndW]

T42 & Varshanswamy,

I've stopped responding to this thread for the same reason(s). It seems that an answer that almost works and needs only a basic understanding of string manipulation to modify so that it performs according to wishes is too much work - the only acceptable response for him/her is something that only needs to be plugged in to work. This is a public and free forum for information exchange and mutual assistance and cannot survive with an attitude like that.

[ray.wurlod]

On the other hand, there are quite a few self-employed consultants and service providers here who would be happy to SELL a customised and working solution. This is what T42 was getting at with "pay someone".