Hello Team:
Can someone shed some light on how to create a similar type layout like the avery labels, for example the avery 8160?
I have a QR code generator and all i need is the layout and also able to have the Item and description below with the barcode in the middle.
Sample attached.
Solved! Go to Solution.
It's possible. Refer to this weekly challenge.
https://community.alteryx.com/t5/Weekly-Challenge/Challenge-99-SANTALYTICS-2017-Part-3/td-p/104120
This was made in Alteryx
Hope this helps : )
Interesting.. I will take a look but this looks scary! LOL
I wouldn't deny that 😅. A suggestion would be to look at people's solutions, pick up the one which looks easiest and try to understand it. That will much better help you.
Hope this helps : )
From looking at your current workflow it looks like the part you're missing is the Overlay tool.
Start with a Report Text that has the descriptions and the two images. Get these all in the same record and use an Overlay tool to add the QR to the top left and the Part image to top middle while using the text as the base field.
Once you get all the labels built in single column use a RecordID and a Formula tool to mark the even and odd rows using the Mod function. Filter out the even and odds and then join the two on record position. This will give you multiple rows with two columns. Use a horizontal layout tool to get the rows and then render. You'll have to play with the column size options to get them to match with the labels.
Dan
Extending on @danilang solution. Here is another way you can reach to expected output in the table format.
I am generating 8 rows (duplicates to be used as dummy data) in your scenario it will be 8+ rows of actual data
After overlay tool use make columns to organize data into 2 columns. Make columns tool organizes rows into a table with n columns. Refer below
After that use table tool to merge it into a single report object. Since we don't need header uncheck show headers in the table tool. And customize table as required.
Use render tool to render it to an output and Viola you get an output like below.
Major credit goes to @danilang for solving and explaining most parts of the problem. I have just added the finishing touches 🙂. And I had learnt how to solve this from the mentioned weekly challenge only😅.
Hope this helps : )
Well I be darned, I am super impressed!! WOWZERS!
Thanks @danilang and @atcodedog05
I want to thank you all for shedding some light and extending my knowledge!😃
Happy to help : ) @txjohnnypops79
Cheers and have a nice day!