Adding record and add more rows for multiple records

[jaemilao]

HI,

I've created an analytic app to compute the partial call percentage. But i need help where i can input how many records i need to input for the computation and produce multiple rows for the multiple records once its outputted. 

Can you help me out on that part?

Thank you

Ive added the workflow and the output file for reference

[jaemilao]

@caltang - these are helpful. one last question. is it possible to add additional control in the end. to make sure the records i put in the input data part is the same with my output? thanks

[jaemilao]

@caltang - that helps out. but 2 things.

i've edited the workflow but formula and the format of field is not correct. can you double check,? (attached file -output)

Then one last thing, is it possible to put a control at the end to check if my inputted records from the start is the same with my output file?

[jaemilao]

@caltang this help out. but 2 more things.

1st - the file in my excel file doesn't show the multiple records in 1 page. how do i do that? and another thing the decimal places, i cannot correct them to the correct type ( see attached file)

2nd - can we put a control in the end to make sure if multiple records were inputted; my output and input will have the same number of records

[caltang]

Here you go.

Try to avoid changing data types with Select Tool even though you can. Use a formula / multi-field formula to change the types with a formula so you can control the data type and size better.

Hope this helps!

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[jaemilao]

@caltang that helps out. but what about the control that i can put in the end to make sure the multiple records were inputted are the same with my output file; even just for the count. that will be my last question. thanks

[caltang · Accepted solution]

@jaemilao 

Here you go. If it was helpful, kindly like & mark as accepted the posts which helped.

Best,

Cal

[jaemilao]

@caltang - I've change the test value to test the error message but it doesnt show up. can you send me a screenshot of the change that will prompt the error message? thanks

[caltang]

By the workflow design it will not show up. Because you choose the inputs as ; delimiter, it will always return a count of rows similar to what you input.

So I was not sure why you needed it, but since you insisted, I gave it to you. 

That should be it.

[jaemilao]

i dont think the macro count records will work as i have the earliest version of the app. but thank you for all the help @caltang 

[caltang]

Update your version then. If it helped, kindly mark the above as accepted solutions so that the thread may close.