create a report

[nkrupabd]

Hi,

I'm trying to create a report of the following format. 

Could someone please help me with this

[saveeshkumar]

@nkrupabd 
could you please present more information on the request.

[nkrupabd]

I want to present the data in the specific format only(the format attached above)

[saveeshkumar]

@nkrupabd 

I have used python tool and xlsxwriter package to render the report in same format.

please find the sample code to above format.

[nkrupabd]

Thank you , But unable to open the workflow can you please send a screen shot, it might be helpful.

[saveeshkumar]

Hi @nkrupabd ,

Please find python code.

from ayx import Alteryx
import xlsxwriter
import pandas as pd
df=Alteryx.read("#1")
print(df)
workbook = xlsxwriter.Workbook('C:\\Community\\Example3.xlsx')
worksheet = workbook.add_worksheet("sheet")
#Line 2
Line1 = (12345678,'Krupabdhi','havish','SZZ1','1/31/2022','E346222770',42,50.02)
row = 1
col = 1

# Iterate over the data and write it out row by row.
for d in (Line1):
#worksheet.write(row, col, df[index])
worksheet.write(row, col, d,cell_border)

col += 1
#Line 5
cell_format = workbook.add_format({'bold': True,'border': 1})
cell_border = workbook.add_format({'border': 1})
Line5 = (['Old Rate',42],['Start Date','12/1/2021'],['End Date','12/5/2021'])
row = 5
col = 3

# Iterate over the data and write it out row by row.
for header,value in (Line5):
#worksheet.write(row, col, df[index])
worksheet.write(row, col, header,cell_format)
worksheet.write(row+1, col, value,cell_border)
#worksheet.write(row+1, col+1, value)

col += 1

#line 9

Line9 = (['Date','Wed 01/12'],['Schedule',''],['Pay Code','Sickness Lv'],['Amount',0])
row = 9
col = 5
for header,value in (Line9):
#worksheet.write(row, col, df[index])
worksheet.write(row, col, header,cell_format)
worksheet.write(row+1, col, value,cell_border)
#worksheet.write(row+1, col+1, value)

col += 1

workbook.close()

Thanks

[nkrupabd]

Thanks a lot .

[nkrupabd]

Hi here the code is generalized to one employee , if we have 10k employees it's not possible to give the details of employees individually.

Please can you suggest if there is any other way.

Thank you

[saveeshkumar]

Hi @nkrupabd ,

could you please provide sample data and output..

[nkrupabd]

Attaching the example input and output.

For every employee based on the name we need to create the output in the format given and each employee needs to be recorded in a different sheet as in the example Dummy_output.

Thank you