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 FruitLocationCostCopy flagApplesEngland100nBananaScotland 500n pearspain 200y I would need the row with pear to be copied FruitLocationCostCopy flagApplesEngland100nBananaScotland500npearspain200ypear_copyspain200Y Hope you can help me many thanks Denny

COPY A ROW OF DATA

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

Preparation

Accepted answers

danielbrun2

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.

Skærmbillede 2016-01-25 kl. 11.14.57.png

I hope it makes sense. If not just say so

Daniel

MichelSza

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

All comments

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

Example workflow.yxmd

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

Example workflow.yxmd

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703