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

[caltang]

Sorry @jaemilao I do not understand your request. Can you show some expected output at least?

[jaemilao]

hi @caltang ,

I've attached the anayltic app workflow for your reference 

ive created this like a form type where you could input the value and it give u the computed partial call percentage.

And this work for 1 input/record at a time

What i want to add or enhance more on this workflow is this.

a. ask me how many records do i need to input -- how can i add this

b. once number if record is indicated.. example : 3

c. then now it will let me input the values for the 3 fields in 3 rows 

d. then once run is click, it produce me the pdf with 3 records containing the partial call percentage for each record.

I was able to create this project for at a time of imput. but to fully utilize the project, it will be better if i can simultaneous put in/encode in multiple records before i click run to compute

Appreciate if you can help me out

Thanks

[caltang]

You would be better off with a mapping file like an excel or text file to achieve your goal. I don’t think Alteryx is capable of accepting tabulated inputs via Analytic Apps, what more dynamic ones. 

I’ll have a closer look tomorrow. This comment is my first impression.

[jaemilao]

Greatly appreciated. but we are trying to remove the excel file, since we want to remove the formula thats why opted to use analytic app so we can go directly the data when we want to run it

its like we are creating a calculator but we want to have the flexibility whether to compute for 1 or more than records

Thanks

[caltang]

Okay @jaemilao I've done this workflow with a workaround to what I mentioned (without Excel):

How it operates is that it uses your text inputs and the ";" as the delimiter to split to rows. You do not need to declare how many rows you want. For example:

The downside is that you have to train your users to write multiple values like so with the ; as a delimiter. 

Each column of the delimiter is tied to its own field, for example:

Field 1;Field 2;Field 3

5000.00;6000.00;7000.00

2535000.00;2535000.00;2535000.00

Input Security ID;Input Security ID;Input Security ID

If your user does not want to fill a field for any reason, then you need to leave it empty like so:

Field 1;Field 2;Field 3

5000.00;;6000.00

This ensures that it always correspond to its appropriate field and will count as such for your formulas etc.

Hope this gives you some ideas. Sadly, there is no table input in Alteryx - you can write it as an idea though!

Hope this helps!

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

[jaemilao]

I think this will work. But one last thing, is it possible to create an additional check for the output produced based on the data inputted.

just to make sure nothing was missed.

my output is in pdf format from render tool

Thanks @caltang 

[jaemilao]

Hi @caltang ,

Can you help me out on this file as well please?

I tried to replicate the same workflow but adding more fields and with a different formula.

But i'm erroring out. can you help me out?

I've attached my unfinished workflow with the screenshots of the error

Thank you 

[caltang]

You need to use ToNumber() for your Dates field. You’re using it as an int, but DateTimeParse / DateTimeFormat returns a string.

[caltang]

@jaemilao here you go. Can you tag me in your replies so that I get the notification? Otherwise I have to periodically check. 

In addition, if my solutions above helped, could you kindly like & mark as accepted solution once you are satisfied? Thanks.