LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: what_to_do

I am hoping someone would be able to assist me with the below graph. Is there a better way to implement the below.

I am basically using 2 x FTP-get nodes and appending the files together - The issue occurs when you run the 2 FTP-Get nodes only one of the files appear to be loaded into both the "excel file" nodes....

Thank you for your guidance in advance


node:Append_Files
bretype:core::Cat
editor:Label=Append Files
editor:sortkey=56e9cb164e0217d7
input:@40fd2c7476b11c42/=File1.48cf6cd2305e5f95
input:56e9cb1c496c139c/out1=File2.48cf6cd2305e5f95
output:@40fd2c74676e03c3/=
prop:ConcatenationMode=union
editor:XY=440,110
end:Append_Files

node:File1
bretype:core::Excel File
editor:Label=File1
editor:sortkey=565d1068226a72ce_41
input:565d1086438a0991/downloaded files=GET_FIle1.5159d635640e372a
output:@48cf6cd2305e5f95/=
prop:DuplicateFieldNameAction=AutoName
prop:FilenameExpr=_DestinationFile
editor:XY=240,60
end:File1

node:File2
bretype:core::Excel File
editor:Label=File2
editor:sortkey=565d1068226a72ce_3
input:565d1086438a0991/downloaded files=Get_File2.5159d635640e372a
output:@48cf6cd2305e5f95/=
prop:DuplicateFieldNameAction=AutoName
prop:FilenameExpr=_DestinationFile
editor:XY=240,170
end:File2

node:GET_FIle1
bretype:lal1::FTP Get
editor:Label=GET FIle1
editor:sortkey=5656249f49f85e15_62
output:@5159d635640e372a/=
output:@52176f675b000707/=
prop:FileExistsBehavior=Overwrite
prop:LocalPath=/mnt/lavastorm/tmp/Pete
prop:Protocol=SFTP
prop:Server=xsyz.mission.com.au
encrypted:simple=nFZhmIpPYUn0JNVhGchaXdZGuwrOymcVZ yvdXfw=
prop:ServerPath=/mnt/array1/File1.xlsx
prop:ServerPort=22
prop:ServerUsername=USERNAME
editor:XY=90,60
end:GET_FIle1

node:Get_File2
bretype:lal1::FTP Get
editor:Label=Get File2
editor:sortkey=5656249f49f85e15
output:@5159d635640e372a/=
output:@52176f675b000707/=
prop:FileExistsBehavior=Overwrite
prop:LocalPath=/mnt/lavastorm/tmp/Pete
prop:Protocol=SFTP
prop:Server=xsyz.mission.com.au
encrypted:simple=nFZhmIpPYUn0JNVhGchaXdZGuwrOymcVZ yvdXfw=
prop:ServerPath=/mnt/array1/File2.xlsx
prop:ServerPort=22
prop:ServerUsername=USERNAME
editor:XY=90,170
end:Get_File2

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

If you hover over LocalPath, it says that you must include the trailing / if you are trying to use a folder.

I think you have both nodes creating the same file "Pete".

Either put a / at the end of the LocalPath, or put the full filename there such as /mnt/lavastorm/tmp/Pete/File1.xlsx

I would also select "Literal" next to each one of the parameters.