What tool can i used to duplicate the values on the 2 fields to the other fields

[jaemilao]

Hi,

I have a problem.

I need to duplicate the rate and date to the rest of the rows of my table and remove all null spaces

but right now, it is located in different rows ( see screenshot attached)

What tool can i used to replicate the 2 columns values to the rest of my rows?

And is it possible for my output file to be in pdf format?

Thanks

[dougperez · Accepted solution]

You can use multi-row to duplicate the values the you can use a filter tool or a sample to skip the first row.

See the workflow attached

[jaemilao]

@dougperez that helps me out thanks. one more thing

i need to add +1 d on my last px date

is there something wrong with my formula

DateTimeFormat(DateTimeAdd(DateTimeParse([Last Px Date],"%d-%b-%y"),+1,"days"),'%d-%b-%Y')

error mesage is  Formula (19) DATETIMEPARSE: Cannot convert "09/07/2022" to a date/time with format "%d-%b-%y" and language "English": Invalid month: '07/2022' -- expected at least three letters

[jaemilao]

@dougperez all ok now. i was able to correct the formula thanks :)

[jaemilao]

@dougperez can you help me out on my last query? is it possible to create another output file in PDF format?

[binuacs · Accepted solution]

@jaemilao you need to add the table tool and the render tool to produce the output in the pdf format

[binuacs · Accepted solution]

@jaemilao Also I made a few changes in your workflow and removed unwanted tools. Attaching the workflow please let me know if you need any additional changes in the workflow.