COPY A ROW OF DATA

[DennyChan]

Hello

hope you are well!

Could anyone advise me if I can copy a row of data to anouther row based on a flaggin system IE with the below example

Fruit	Location	Cost	Copy flag
Apples	England	100	n
Banana	Scotland	500	n
pear	spain	200	y

I would need the row with pear to be copied

Fruit	Location	Cost	Copy flag
Apples	England	100	n
Banana	Scotland	500	n
pear	spain	200	y
pear_copy	spain	200	Y

Hope you can help me

many thanks

Denny

[danielbrun2]

Hi Denny,

I would do something like the attached.

I take all the records with copy flag, and add union them on the existing dataset (after adding a copy to the fruit name).

Best regards,

Daniel

[danielbrun2]

Hi Denny,

I would do something like the attached.

I take all the records with copy flag, and add union them on the existing dataset (after adding a copy to the fruit name).

Best regards,

Daniel

[DennyChan]

Thank you daniel for the Speedy response

could you resend the workflow in an earlier version as i am running 9.5.10.544 and i get a message saying i cant open your example

many thanks

Denny

[danielbrun2 · Accepted solution]

You are welcome.

Unfortunately I do not have acess to an older version at the moment. I have attached a picture of the workflow. The select in the beginning is just used for extending the datatype for the fruit name.

I hope it makes sense. If not just say so :)

Daniel

[DennyChan]

many thanks Daniel

[MichelSza · Accepted solution]

BTW, you can open a workflow from a new version in a previous version of Alteryx. 

ie "This document was created by a more recent version of this application and cannot be read".

Just open the workflow with a text editor (notepad++ for instance) and change the value of "yxmdVer" to the right version.

In your case yxmdVer="9.5" . and voila*.

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="10.0">

...

This trick comes from a Alteryx PS guru.

* BTW, It could still not work if there are macros and/or tools built for the newer version but it is worth trying.

Michel